The String Right node is used to include only a substring consisting of a given number of characters from a string column, moving from right to left. This is useful if the string contains a suffix that is private or not relevant for end-users for example.
Take the Right String
Start by connecting the String Right node to the Select node of the relevant table. Go to the Properties panel to define the substring:
- Select Column: choose the relevant column from the drop down.
- Characters to Take: enter the number of characters to be included in the substring, from right to left.
- Column Output: decide whether or not to keep the original column.
- New Column Name: name the new column.
Example: Take the Right Substring
In this example, the last 7 characters of the transactionID string column is included:
Related information
Common Properties
There are a number of fields that are present in the Properties panel when you have any of the preceding nodes selected on the canvas. These fields include Result Properties, Column Selection, Set Variable Values, and Metadata.
- Click here for more details about the Common Properties